<?php
/**
 * Description:
 * Created by PhpStorm.
 * User: bililovy
 * Date: 19-12-14
 * Time: 下午3:36
 */


namespace ServiceSdk\Utils\FileManage;

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Style\Alignment;

class File
{
    /**
     * An array of extension to MIME types.
     *
     * @var array
     */
    protected static $mimes = [
        'ez'          => 'application/andrew-inset',
        'aw'          => 'application/applixware',
        'atom'        => 'application/atom+xml',
        'atomcat'     => 'application/atomcat+xml',
        'atomsvc'     => 'application/atomsvc+xml',
        'ccxml'       => 'application/ccxml+xml',
        'cdmia'       => 'application/cdmi-capability',
        'cdmic'       => 'application/cdmi-container',
        'cdmid'       => 'application/cdmi-domain',
        'cdmio'       => 'application/cdmi-object',
        'cdmiq'       => 'application/cdmi-queue',
        'cu'          => 'application/cu-seeme',
        'davmount'    => 'application/davmount+xml',
        'dbk'         => 'application/docbook+xml',
        'dssc'        => 'application/dssc+der',
        'xdssc'       => 'application/dssc+xml',
        'ecma'        => 'application/ecmascript',
        'emma'        => 'application/emma+xml',
        'epub'        => 'application/epub+zip',
        'exi'         => 'application/exi',
        'pfr'         => 'application/font-tdpfr',
        'gml'         => 'application/gml+xml',
        'gpx'         => 'application/gpx+xml',
        'gxf'         => 'application/gxf',
        'stk'         => 'application/hyperstudio',
        'ink'         => 'application/inkml+xml',
        'ipfix'       => 'application/ipfix',
        'jar'         => 'application/java-archive',
        'ser'         => 'application/java-serialized-object',
        'class'       => 'application/java-vm',
        'js'          => 'application/javascript',
        'json'        => 'application/json',
        'jsonml'      => 'application/jsonml+json',
        'lostxml'     => 'application/lost+xml',
        'hqx'         => 'application/mac-binhex40',
        'cpt'         => 'application/mac-compactpro',
        'mads'        => 'application/mads+xml',
        'mrc'         => 'application/marc',
        'mrcx'        => 'application/marcxml+xml',
        'ma'          => 'application/mathematica',
        'mathml'      => 'application/mathml+xml',
        'mbox'        => 'application/mbox',
        'mscml'       => 'application/mediaservercontrol+xml',
        'metalink'    => 'application/metalink+xml',
        'meta4'       => 'application/metalink4+xml',
        'mets'        => 'application/mets+xml',
        'mods'        => 'application/mods+xml',
        'm21'         => 'application/mp21',
        'mp4s'        => 'application/mp4',
        'doc'         => 'application/msword',
        'mxf'         => 'application/mxf',
        'bin'         => 'application/octet-stream',
        'oda'         => 'application/oda',
        'opf'         => 'application/oebps-package+xml',
        'ogx'         => 'application/ogg',
        'omdoc'       => 'application/omdoc+xml',
        'onetoc'      => 'application/onenote',
        'oxps'        => 'application/oxps',
        'xer'         => 'application/patch-ops-error+xml',
        'pdf'         => 'application/pdf',
        'pgp'         => 'application/pgp-encrypted',
        'asc'         => 'application/pgp-signature',
        'prf'         => 'application/pics-rules',
        'p10'         => 'application/pkcs10',
        'p7m'         => 'application/pkcs7-mime',
        'p7s'         => 'application/pkcs7-signature',
        'p8'          => 'application/pkcs8',
        'ac'          => 'application/pkix-attr-cert',
        'cer'         => 'application/pkix-cert',
        'crl'         => 'application/pkix-crl',
        'pkipath'     => 'application/pkix-pkipath',
        'pki'         => 'application/pkixcmp',
        'pls'         => 'application/pls+xml',
        'ai'          => 'application/postscript',
        'cww'         => 'application/prs.cww',
        'pskcxml'     => 'application/pskc+xml',
        'rdf'         => 'application/rdf+xml',
        'rif'         => 'application/reginfo+xml',
        'rnc'         => 'application/relax-ng-compact-syntax',
        'rl'          => 'application/resource-lists+xml',
        'rld'         => 'application/resource-lists-diff+xml',
        'rs'          => 'application/rls-services+xml',
        'gbr'         => 'application/rpki-ghostbusters',
        'mft'         => 'application/rpki-manifest',
        'roa'         => 'application/rpki-roa',
        'rsd'         => 'application/rsd+xml',
        'rss'         => 'application/rss+xml',
        'sbml'        => 'application/sbml+xml',
        'scq'         => 'application/scvp-cv-request',
        'scs'         => 'application/scvp-cv-response',
        'spq'         => 'application/scvp-vp-request',
        'spp'         => 'application/scvp-vp-response',
        'sdp'         => 'application/sdp',
        'setpay'      => 'application/set-payment-initiation',
        'setreg'      => 'application/set-registration-initiation',
        'shf'         => 'application/shf+xml',
        'smi'         => 'application/smil+xml',
        'rq'          => 'application/sparql-query',
        'srx'         => 'application/sparql-results+xml',
        'gram'        => 'application/srgs',
        'grxml'       => 'application/srgs+xml',
        'sru'         => 'application/sru+xml',
        'ssdl'        => 'application/ssdl+xml',
        'ssml'        => 'application/ssml+xml',
        'tei'         => 'application/tei+xml',
        'tfi'         => 'application/thraud+xml',
        'tsd'         => 'application/timestamped-data',
        'plb'         => 'application/vnd.3gpp.pic-bw-large',
        'psb'         => 'application/vnd.3gpp.pic-bw-small',
        'pvb'         => 'application/vnd.3gpp.pic-bw-var',
        'tcap'        => 'application/vnd.3gpp2.tcap',
        'pwn'         => 'application/vnd.3m.post-it-notes',
        'aso'         => 'application/vnd.accpac.simply.aso',
        'imp'         => 'application/vnd.accpac.simply.imp',
        'acu'         => 'application/vnd.acucobol',
        'atc'         => 'application/vnd.acucorp',
        'air'         => 'application/vnd.adobe.air-application-installer-package+zip',
        'fcdt'        => 'application/vnd.adobe.formscentral.fcdt',
        'fxp'         => 'application/vnd.adobe.fxp',
        'xdp'         => 'application/vnd.adobe.xdp+xml',
        'xfdf'        => 'application/vnd.adobe.xfdf',
        'ahead'       => 'application/vnd.ahead.space',
        'azf'         => 'application/vnd.airzip.filesecure.azf',
        'azs'         => 'application/vnd.airzip.filesecure.azs',
        'azw'         => 'application/vnd.amazon.ebook',
        'acc'         => 'application/vnd.americandynamics.acc',
        'ami'         => 'application/vnd.amiga.ami',
        'apk'         => 'application/vnd.android.package-archive',
        'cii'         => 'application/vnd.anser-web-certificate-issue-initiation',
        'fti'         => 'application/vnd.anser-web-funds-transfer-initiation',
        'atx'         => 'application/vnd.antix.game-component',
        'mpkg'        => 'application/vnd.apple.installer+xml',
        'm3u8'        => 'application/vnd.apple.mpegurl',
        'swi'         => 'application/vnd.aristanetworks.swi',
        'iota'        => 'application/vnd.astraea-software.iota',
        'aep'         => 'application/vnd.audiograph',
        'mpm'         => 'application/vnd.blueice.multipass',
        'bmi'         => 'application/vnd.bmi',
        'rep'         => 'application/vnd.businessobjects',
        'cdxml'       => 'application/vnd.chemdraw+xml',
        'mmd'         => 'application/vnd.chipnuts.karaoke-mmd',
        'cdy'         => 'application/vnd.cinderella',
        'cla'         => 'application/vnd.claymore',
        'rp9'         => 'application/vnd.cloanto.rp9',
        'c4g'         => 'application/vnd.clonk.c4group',
        'c11amc'      => 'application/vnd.cluetrust.cartomobile-config',
        'c11amz'      => 'application/vnd.cluetrust.cartomobile-config-pkg',
        'csp'         => 'application/vnd.commonspace',
        'cdbcmsg'     => 'application/vnd.contact.cmsg',
        'cmc'         => 'application/vnd.cosmocaller',
        'clkx'        => 'application/vnd.crick.clicker',
        'clkk'        => 'application/vnd.crick.clicker.keyboard',
        'clkp'        => 'application/vnd.crick.clicker.palette',
        'clkt'        => 'application/vnd.crick.clicker.template',
        'clkw'        => 'application/vnd.crick.clicker.wordbank',
        'wbs'         => 'application/vnd.criticaltools.wbs+xml',
        'pml'         => 'application/vnd.ctc-posml',
        'ppd'         => 'application/vnd.cups-ppd',
        'car'         => 'application/vnd.curl.car',
        'pcurl'       => 'application/vnd.curl.pcurl',
        'dart'        => 'application/vnd.dart',
        'rdz'         => 'application/vnd.data-vision.rdz',
        'uvf'         => 'application/vnd.dece.data',
        'uvt'         => 'application/vnd.dece.ttml+xml',
        'uvx'         => 'application/vnd.dece.unspecified',
        'uvz'         => 'application/vnd.dece.zip',
        'fe_launch'   => 'application/vnd.denovo.fcselayout-link',
        'dna'         => 'application/vnd.dna',
        'mlp'         => 'application/vnd.dolby.mlp',
        'dpg'         => 'application/vnd.dpgraph',
        'dfac'        => 'application/vnd.dreamfactory',
        'kpxx'        => 'application/vnd.ds-keypoint',
        'ait'         => 'application/vnd.dvb.ait',
        'svc'         => 'application/vnd.dvb.service',
        'geo'         => 'application/vnd.dynageo',
        'mag'         => 'application/vnd.ecowin.chart',
        'nml'         => 'application/vnd.enliven',
        'esf'         => 'application/vnd.epson.esf',
        'msf'         => 'application/vnd.epson.msf',
        'qam'         => 'application/vnd.epson.quickanime',
        'slt'         => 'application/vnd.epson.salt',
        'ssf'         => 'application/vnd.epson.ssf',
        'es3'         => 'application/vnd.eszigno3+xml',
        'ez2'         => 'application/vnd.ezpix-album',
        'ez3'         => 'application/vnd.ezpix-package',
        'fdf'         => 'application/vnd.fdf',
        'mseed'       => 'application/vnd.fdsn.mseed',
        'seed'        => 'application/vnd.fdsn.seed',
        'gph'         => 'application/vnd.flographit',
        'ftc'         => 'application/vnd.fluxtime.clip',
        'fm'          => 'application/vnd.framemaker',
        'fnc'         => 'application/vnd.frogans.fnc',
        'ltf'         => 'application/vnd.frogans.ltf',
        'fsc'         => 'application/vnd.fsc.weblaunch',
        'oas'         => 'application/vnd.fujitsu.oasys',
        'oa2'         => 'application/vnd.fujitsu.oasys2',
        'oa3'         => 'application/vnd.fujitsu.oasys3',
        'fg5'         => 'application/vnd.fujitsu.oasysgp',
        'bh2'         => 'application/vnd.fujitsu.oasysprs',
        'ddd'         => 'application/vnd.fujixerox.ddd',
        'xdw'         => 'application/vnd.fujixerox.docuworks',
        'xbd'         => 'application/vnd.fujixerox.docuworks.binder',
        'fzs'         => 'application/vnd.fuzzysheet',
        'txd'         => 'application/vnd.genomatix.tuxedo',
        'ggb'         => 'application/vnd.geogebra.file',
        'ggt'         => 'application/vnd.geogebra.tool',
        'gex'         => 'application/vnd.geometry-explorer',
        'gxt'         => 'application/vnd.geonext',
        'g2w'         => 'application/vnd.geoplan',
        'g3w'         => 'application/vnd.geospace',
        'gmx'         => 'application/vnd.gmx',
        'kml'         => 'application/vnd.google-earth.kml+xml',
        'kmz'         => 'application/vnd.google-earth.kmz',
        'gqf'         => 'application/vnd.grafeq',
        'gac'         => 'application/vnd.groove-account',
        'ghf'         => 'application/vnd.groove-help',
        'gim'         => 'application/vnd.groove-identity-message',
        'grv'         => 'application/vnd.groove-injector',
        'gtm'         => 'application/vnd.groove-tool-message',
        'tpl'         => 'application/vnd.groove-tool-template',
        'vcg'         => 'application/vnd.groove-vcard',
        'hal'         => 'application/vnd.hal+xml',
        'zmm'         => 'application/vnd.handheld-entertainment+xml',
        'hbci'        => 'application/vnd.hbci',
        'les'         => 'application/vnd.hhe.lesson-player',
        'hpgl'        => 'application/vnd.hp-hpgl',
        'hpid'        => 'application/vnd.hp-hpid',
        'hps'         => 'application/vnd.hp-hps',
        'jlt'         => 'application/vnd.hp-jlyt',
        'pcl'         => 'application/vnd.hp-pcl',
        'pclxl'       => 'application/vnd.hp-pclxl',
        'sfd-hdstx'   => 'application/vnd.hydrostatix.sof-data',
        'mpy'         => 'application/vnd.ibm.minipay',
        'afp'         => 'application/vnd.ibm.modcap',
        'irm'         => 'application/vnd.ibm.rights-management',
        'sc'          => 'application/vnd.ibm.secure-container',
        'icc'         => 'application/vnd.iccprofile',
        'igl'         => 'application/vnd.igloader',
        'ivp'         => 'application/vnd.immervision-ivp',
        'ivu'         => 'application/vnd.immervision-ivu',
        'igm'         => 'application/vnd.insors.igm',
        'xpw'         => 'application/vnd.intercon.formnet',
        'i2g'         => 'application/vnd.intergeo',
        'qbo'         => 'application/vnd.intu.qbo',
        'qfx'         => 'application/vnd.intu.qfx',
        'rcprofile'   => 'application/vnd.ipunplugged.rcprofile',
        'irp'         => 'application/vnd.irepository.package+xml',
        'xpr'         => 'application/vnd.is-xpr',
        'fcs'         => 'application/vnd.isac.fcs',
        'jam'         => 'application/vnd.jam',
        'rms'         => 'application/vnd.jcp.javame.midlet-rms',
        'jisp'        => 'application/vnd.jisp',
        'joda'        => 'application/vnd.joost.joda-archive',
        'ktz'         => 'application/vnd.kahootz',
        'karbon'      => 'application/vnd.kde.karbon',
        'chrt'        => 'application/vnd.kde.kchart',
        'kfo'         => 'application/vnd.kde.kformula',
        'flw'         => 'application/vnd.kde.kivio',
        'kon'         => 'application/vnd.kde.kontour',
        'kpr'         => 'application/vnd.kde.kpresenter',
        'ksp'         => 'application/vnd.kde.kspread',
        'kwd'         => 'application/vnd.kde.kword',
        'htke'        => 'application/vnd.kenameaapp',
        'kia'         => 'application/vnd.kidspiration',
        'kne'         => 'application/vnd.kinar',
        'skp'         => 'application/vnd.koan',
        'sse'         => 'application/vnd.kodak-descriptor',
        'lasxml'      => 'application/vnd.las.las+xml',
        'lbd'         => 'application/vnd.llamagraphics.life-balance.desktop',
        'lbe'         => 'application/vnd.llamagraphics.life-balance.exchange+xml',
        '123'         => 'application/vnd.lotus-1-2-3',
        'apr'         => 'application/vnd.lotus-approach',
        'pre'         => 'application/vnd.lotus-freelance',
        'nsf'         => 'application/vnd.lotus-notes',
        'org'         => 'application/vnd.lotus-organizer',
        'scm'         => 'application/vnd.lotus-screencam',
        'lwp'         => 'application/vnd.lotus-wordpro',
        'portpkg'     => 'application/vnd.macports.portpkg',
        'mcd'         => 'application/vnd.mcd',
        'mc1'         => 'application/vnd.medcalcdata',
        'cdkey'       => 'application/vnd.mediastation.cdkey',
        'mwf'         => 'application/vnd.mfer',
        'mfm'         => 'application/vnd.mfmp',
        'flo'         => 'application/vnd.micrografx.flo',
        'igx'         => 'application/vnd.micrografx.igx',
        'mif'         => 'application/vnd.mif',
        'daf'         => 'application/vnd.mobius.daf',
        'dis'         => 'application/vnd.mobius.dis',
        'mbk'         => 'application/vnd.mobius.mbk',
        'mqy'         => 'application/vnd.mobius.mqy',
        'msl'         => 'application/vnd.mobius.msl',
        'plc'         => 'application/vnd.mobius.plc',
        'txf'         => 'application/vnd.mobius.txf',
        'mpn'         => 'application/vnd.mophun.application',
        'mpc'         => 'application/vnd.mophun.certificate',
        'xul'         => 'application/vnd.mozilla.xul+xml',
        'cil'         => 'application/vnd.ms-artgalry',
        'cab'         => 'application/vnd.ms-cab-compressed',
        'xls'         => 'application/vnd.ms-excel',
        'xlam'        => 'application/vnd.ms-excel.addin.macroenabled.12',
        'xlsb'        => 'application/vnd.ms-excel.sheet.binary.macroenabled.12',
        'xlsm'        => 'application/vnd.ms-excel.sheet.macroenabled.12',
        'xltm'        => 'application/vnd.ms-excel.template.macroenabled.12',
        'eot'         => 'application/vnd.ms-fontobject',
        'chm'         => 'application/vnd.ms-htmlhelp',
        'ims'         => 'application/vnd.ms-ims',
        'lrm'         => 'application/vnd.ms-lrm',
        'thmx'        => 'application/vnd.ms-officetheme',
        'cat'         => 'application/vnd.ms-pki.seccat',
        'stl'         => 'application/vnd.ms-pki.stl',
        'ppt'         => 'application/vnd.ms-powerpoint',
        'ppam'        => 'application/vnd.ms-powerpoint.addin.macroenabled.12',
        'pptm'        => 'application/vnd.ms-powerpoint.presentation.macroenabled.12',
        'sldm'        => 'application/vnd.ms-powerpoint.slide.macroenabled.12',
        'ppsm'        => 'application/vnd.ms-powerpoint.slideshow.macroenabled.12',
        'potm'        => 'application/vnd.ms-powerpoint.template.macroenabled.12',
        'mpp'         => 'application/vnd.ms-project',
        'docm'        => 'application/vnd.ms-word.document.macroenabled.12',
        'dotm'        => 'application/vnd.ms-word.template.macroenabled.12',
        'wps'         => 'application/vnd.ms-works',
        'wpl'         => 'application/vnd.ms-wpl',
        'xps'         => 'application/vnd.ms-xpsdocument',
        'mseq'        => 'application/vnd.mseq',
        'mus'         => 'application/vnd.musician',
        'msty'        => 'application/vnd.muvee.style',
        'taglet'      => 'application/vnd.mynfc',
        'nlu'         => 'application/vnd.neurolanguage.nlu',
        'ntf'         => 'application/vnd.nitf',
        'nnd'         => 'application/vnd.noblenet-directory',
        'nns'         => 'application/vnd.noblenet-sealer',
        'nnw'         => 'application/vnd.noblenet-web',
        'ngdat'       => 'application/vnd.nokia.n-gage.data',
        'n-gage'      => 'application/vnd.nokia.n-gage.symbian.install',
        'rpst'        => 'application/vnd.nokia.radio-preset',
        'rpss'        => 'application/vnd.nokia.radio-presets',
        'edm'         => 'application/vnd.novadigm.edm',
        'edx'         => 'application/vnd.novadigm.edx',
        'ext'         => 'application/vnd.novadigm.ext',
        'odc'         => 'application/vnd.oasis.opendocument.chart',
        'otc'         => 'application/vnd.oasis.opendocument.chart-template',
        'odb'         => 'application/vnd.oasis.opendocument.database',
        'odf'         => 'application/vnd.oasis.opendocument.formula',
        'odft'        => 'application/vnd.oasis.opendocument.formula-template',
        'odg'         => 'application/vnd.oasis.opendocument.graphics',
        'otg'         => 'application/vnd.oasis.opendocument.graphics-template',
        'odi'         => 'application/vnd.oasis.opendocument.image',
        'oti'         => 'application/vnd.oasis.opendocument.image-template',
        'odp'         => 'application/vnd.oasis.opendocument.presentation',
        'otp'         => 'application/vnd.oasis.opendocument.presentation-template',
        'ods'         => 'application/vnd.oasis.opendocument.spreadsheet',
        'ots'         => 'application/vnd.oasis.opendocument.spreadsheet-template',
        'odt'         => 'application/vnd.oasis.opendocument.text',
        'odm'         => 'application/vnd.oasis.opendocument.text-master',
        'ott'         => 'application/vnd.oasis.opendocument.text-template',
        'oth'         => 'application/vnd.oasis.opendocument.text-web',
        'xo'          => 'application/vnd.olpc-sugar',
        'dd2'         => 'application/vnd.oma.dd2+xml',
        'oxt'         => 'application/vnd.openofficeorg.extension',
        'pptx'        => 'application/vnd.openxmlformats-officedocument.presentationml.presentation',
        'sldx'        => 'application/vnd.openxmlformats-officedocument.presentationml.slide',
        'ppsx'        => 'application/vnd.openxmlformats-officedocument.presentationml.slideshow',
        'potx'        => 'application/vnd.openxmlformats-officedocument.presentationml.template',
        'xlsx'        => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
        'xltx'        => 'application/vnd.openxmlformats-officedocument.spreadsheetml.template',
        'docx'        => 'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
        'dotx'        => 'application/vnd.openxmlformats-officedocument.wordprocessingml.template',
        'mgp'         => 'application/vnd.osgeo.mapguide.package',
        'dp'          => 'application/vnd.osgi.dp',
        'esa'         => 'application/vnd.osgi.subsystem',
        'pdb'         => 'application/vnd.palm',
        'paw'         => 'application/vnd.pawaafile',
        'str'         => 'application/vnd.pg.format',
        'ei6'         => 'application/vnd.pg.osasli',
        'efif'        => 'application/vnd.picsel',
        'wg'          => 'application/vnd.pmi.widget',
        'plf'         => 'application/vnd.pocketlearn',
        'pbd'         => 'application/vnd.powerbuilder6',
        'box'         => 'application/vnd.previewsystems.box',
        'mgz'         => 'application/vnd.proteus.magazine',
        'qps'         => 'application/vnd.publishare-delta-tree',
        'ptid'        => 'application/vnd.pvi.ptid1',
        'qxd'         => 'application/vnd.quark.quarkxpress',
        'bed'         => 'application/vnd.realvnc.bed',
        'mxl'         => 'application/vnd.recordare.musicxml',
        'musicxml'    => 'application/vnd.recordare.musicxml+xml',
        'cryptonote'  => 'application/vnd.rig.cryptonote',
        'cod'         => 'application/vnd.rim.cod',
        'rm'          => 'application/vnd.rn-realmedia',
        'rmvb'        => 'application/vnd.rn-realmedia-vbr',
        'link66'      => 'application/vnd.route66.link66+xml',
        'st'          => 'application/vnd.sailingtracker.track',
        'see'         => 'application/vnd.seemail',
        'sema'        => 'application/vnd.sema',
        'semd'        => 'application/vnd.semd',
        'semf'        => 'application/vnd.semf',
        'ifm'         => 'application/vnd.shana.informed.formdata',
        'itp'         => 'application/vnd.shana.informed.formtemplate',
        'iif'         => 'application/vnd.shana.informed.interchange',
        'ipk'         => 'application/vnd.shana.informed.package',
        'twd'         => 'application/vnd.simtech-mindmapper',
        'mmf'         => 'application/vnd.smaf',
        'teacher'     => 'application/vnd.smart.teacher',
        'sdkm'        => 'application/vnd.solent.sdkm+xml',
        'dxp'         => 'application/vnd.spotfire.dxp',
        'sfs'         => 'application/vnd.spotfire.sfs',
        'sdc'         => 'application/vnd.stardivision.calc',
        'sda'         => 'application/vnd.stardivision.draw',
        'sdd'         => 'application/vnd.stardivision.impress',
        'smf'         => 'application/vnd.stardivision.math',
        'sdw'         => 'application/vnd.stardivision.writer',
        'sgl'         => 'application/vnd.stardivision.writer-global',
        'smzip'       => 'application/vnd.stepmania.package',
        'sm'          => 'application/vnd.stepmania.stepchart',
        'sxc'         => 'application/vnd.sun.xml.calc',
        'stc'         => 'application/vnd.sun.xml.calc.template',
        'sxd'         => 'application/vnd.sun.xml.draw',
        'std'         => 'application/vnd.sun.xml.draw.template',
        'sxi'         => 'application/vnd.sun.xml.impress',
        'sti'         => 'application/vnd.sun.xml.impress.template',
        'sxm'         => 'application/vnd.sun.xml.math',
        'sxw'         => 'application/vnd.sun.xml.writer',
        'sxg'         => 'application/vnd.sun.xml.writer.global',
        'stw'         => 'application/vnd.sun.xml.writer.template',
        'sus'         => 'application/vnd.sus-calendar',
        'svd'         => 'application/vnd.svd',
        'sis'         => 'application/vnd.symbian.install',
        'xsm'         => 'application/vnd.syncml+xml',
        'bdm'         => 'application/vnd.syncml.dm+wbxml',
        'xdm'         => 'application/vnd.syncml.dm+xml',
        'tao'         => 'application/vnd.tao.intent-module-archive',
        'pcap'        => 'application/vnd.tcpdump.pcap',
        'tmo'         => 'application/vnd.tmobile-livetv',
        'tpt'         => 'application/vnd.trid.tpt',
        'mxs'         => 'application/vnd.triscape.mxs',
        'tra'         => 'application/vnd.trueapp',
        'ufd'         => 'application/vnd.ufdl',
        'utz'         => 'application/vnd.uiq.theme',
        'umj'         => 'application/vnd.umajin',
        'unityweb'    => 'application/vnd.unity',
        'uoml'        => 'application/vnd.uoml+xml',
        'vcx'         => 'application/vnd.vcx',
        'vsd'         => 'application/vnd.visio',
        'vis'         => 'application/vnd.visionary',
        'vsf'         => 'application/vnd.vsf',
        'wbxml'       => 'application/vnd.wap.wbxml',
        'wmlc'        => 'application/vnd.wap.wmlc',
        'wmlsc'       => 'application/vnd.wap.wmlscriptc',
        'wtb'         => 'application/vnd.webturbo',
        'nbp'         => 'application/vnd.wolfram.player',
        'wpd'         => 'application/vnd.wordperfect',
        'wqd'         => 'application/vnd.wqd',
        'stf'         => 'application/vnd.wt.stf',
        'xar'         => 'application/vnd.xara',
        'xfdl'        => 'application/vnd.xfdl',
        'hvd'         => 'application/vnd.yamaha.hv-dic',
        'hvs'         => 'application/vnd.yamaha.hv-script',
        'hvp'         => 'application/vnd.yamaha.hv-voice',
        'osf'         => 'application/vnd.yamaha.openscoreformat',
        'osfpvg'      => 'application/vnd.yamaha.openscoreformat.osfpvg+xml',
        'saf'         => 'application/vnd.yamaha.smaf-audio',
        'spf'         => 'application/vnd.yamaha.smaf-phrase',
        'cmp'         => 'application/vnd.yellowriver-custom-menu',
        'zir'         => 'application/vnd.zul',
        'zaz'         => 'application/vnd.zzazz.deck+xml',
        'vxml'        => 'application/voicexml+xml',
        'wgt'         => 'application/widget',
        'hlp'         => 'application/winhlp',
        'wsdl'        => 'application/wsdl+xml',
        'wspolicy'    => 'application/wspolicy+xml',
        '7z'          => 'application/x-7z-compressed',
        'abw'         => 'application/x-abiword',
        'ace'         => 'application/x-ace-compressed',
        'dmg'         => 'application/x-apple-diskimage',
        'aab'         => 'application/x-authorware-bin',
        'aam'         => 'application/x-authorware-map',
        'aas'         => 'application/x-authorware-seg',
        'bcpio'       => 'application/x-bcpio',
        'torrent'     => 'application/x-bittorrent',
        'blb'         => 'application/x-blorb',
        'bz'          => 'application/x-bzip',
        'bz2'         => 'application/x-bzip2',
        'cbr'         => 'application/x-cbr',
        'vcd'         => 'application/x-cdlink',
        'cfs'         => 'application/x-cfs-compressed',
        'chat'        => 'application/x-chat',
        'pgn'         => 'application/x-chess-pgn',
        'nsc'         => 'application/x-conference',
        'cpio'        => 'application/x-cpio',
        'csh'         => 'application/x-csh',
        'deb'         => 'application/x-debian-package',
        'dgc'         => 'application/x-dgc-compressed',
        'dir'         => 'application/x-director',
        'wad'         => 'application/x-doom',
        'ncx'         => 'application/x-dtbncx+xml',
        'dtb'         => 'application/x-dtbook+xml',
        'res'         => 'application/x-dtbresource+xml',
        'dvi'         => 'application/x-dvi',
        'evy'         => 'application/x-envoy',
        'eva'         => 'application/x-eva',
        'bdf'         => 'application/x-font-bdf',
        'gsf'         => 'application/x-font-ghostscript',
        'psf'         => 'application/x-font-linux-psf',
        'otf'         => 'application/x-font-otf',
        'pcf'         => 'application/x-font-pcf',
        'snf'         => 'application/x-font-snf',
        'ttf'         => 'application/x-font-ttf',
        'pfa'         => 'application/x-font-type1',
        'woff'        => 'application/x-font-woff',
        'arc'         => 'application/x-freearc',
        'spl'         => 'application/x-futuresplash',
        'gca'         => 'application/x-gca-compressed',
        'ulx'         => 'application/x-glulx',
        'gnumeric'    => 'application/x-gnumeric',
        'gramps'      => 'application/x-gramps-xml',
        'gtar'        => 'application/x-gtar',
        'hdf'         => 'application/x-hdf',
        'install'     => 'application/x-install-instructions',
        'iso'         => 'application/x-iso9660-image',
        'jnlp'        => 'application/x-java-jnlp-file',
        'latex'       => 'application/x-latex',
        'lzh'         => 'application/x-lzh-compressed',
        'mie'         => 'application/x-mie',
        'prc'         => 'application/x-mobipocket-ebook',
        'application' => 'application/x-ms-application',
        'lnk'         => 'application/x-ms-shortcut',
        'wmd'         => 'application/x-ms-wmd',
        'wmz'         => 'application/x-ms-wmz',
        'xbap'        => 'application/x-ms-xbap',
        'mdb'         => 'application/x-msaccess',
        'obd'         => 'application/x-msbinder',
        'crd'         => 'application/x-mscardfile',
        'clp'         => 'application/x-msclip',
        'exe'         => 'application/x-msdownload',
        'mvb'         => 'application/x-msmediaview',
        'wmf'         => 'application/x-msmetafile',
        'mny'         => 'application/x-msmoney',
        'pub'         => 'application/x-mspublisher',
        'scd'         => 'application/x-msschedule',
        'trm'         => 'application/x-msterminal',
        'wri'         => 'application/x-mswrite',
        'nc'          => 'application/x-netcdf',
        'nzb'         => 'application/x-nzb',
        'p12'         => 'application/x-pkcs12',
        'p7b'         => 'application/x-pkcs7-certificates',
        'p7r'         => 'application/x-pkcs7-certreqresp',
        'rar'         => 'application/x-rar',
        'ris'         => 'application/x-research-info-systems',
        'sh'          => 'application/x-sh',
        'shar'        => 'application/x-shar',
        'swf'         => 'application/x-shockwave-flash',
        'xap'         => 'application/x-silverlight-app',
        'sql'         => 'application/x-sql',
        'sit'         => 'application/x-stuffit',
        'sitx'        => 'application/x-stuffitx',
        'srt'         => 'application/x-subrip',
        'sv4cpio'     => 'application/x-sv4cpio',
        'sv4crc'      => 'application/x-sv4crc',
        't3'          => 'application/x-t3vm-image',
        'gam'         => 'application/x-tads',
        'tar'         => 'application/x-tar',
        'tcl'         => 'application/x-tcl',
        'tex'         => 'application/x-tex',
        'tfm'         => 'application/x-tex-tfm',
        'texinfo'     => 'application/x-texinfo',
        'obj'         => 'application/x-tgif',
        'ustar'       => 'application/x-ustar',
        'src'         => 'application/x-wais-source',
        'der'         => 'application/x-x509-ca-cert',
        'fig'         => 'application/x-xfig',
        'xlf'         => 'application/x-xliff+xml',
        'xpi'         => 'application/x-xpinstall',
        'xz'          => 'application/x-xz',
        'z1'          => 'application/x-zmachine',
        'xaml'        => 'application/xaml+xml',
        'xdf'         => 'application/xcap-diff+xml',
        'xenc'        => 'application/xenc+xml',
        'xhtml'       => 'application/xhtml+xml',
        'xml'         => 'application/xml',
        'dtd'         => 'application/xml-dtd',
        'xop'         => 'application/xop+xml',
        'xpl'         => 'application/xproc+xml',
        'xslt'        => 'application/xslt+xml',
        'xspf'        => 'application/xspf+xml',
        'mxml'        => 'application/xv+xml',
        'yang'        => 'application/yang',
        'yin'         => 'application/yin+xml',
        'zip'         => 'application/zip',
        'adp'         => 'audio/adpcm',
        'au'          => 'audio/basic',
        'mid'         => 'audio/midi',
        'mp3'         => 'audio/mpeg',
        'mp4a'        => 'audio/mp4',
        'mpga'        => 'audio/mpeg',
        'oga'         => 'audio/ogg',
        's3m'         => 'audio/s3m',
        'sil'         => 'audio/silk',
        'uva'         => 'audio/vnd.dece.audio',
        'eol'         => 'audio/vnd.digital-winds',
        'dra'         => 'audio/vnd.dra',
        'dts'         => 'audio/vnd.dts',
        'dtshd'       => 'audio/vnd.dts.hd',
        'lvp'         => 'audio/vnd.lucent.voice',
        'pya'         => 'audio/vnd.ms-playready.media.pya',
        'ecelp4800'   => 'audio/vnd.nuera.ecelp4800',
        'ecelp7470'   => 'audio/vnd.nuera.ecelp7470',
        'ecelp9600'   => 'audio/vnd.nuera.ecelp9600',
        'rip'         => 'audio/vnd.rip',
        'weba'        => 'audio/webm',
        'aac'         => 'audio/x-aac',
        'aif'         => 'audio/x-aiff',
        'caf'         => 'audio/x-caf',
        'flac'        => 'audio/x-flac',
        'mka'         => 'audio/x-matroska',
        'm3u'         => 'audio/x-mpegurl',
        'wax'         => 'audio/x-ms-wax',
        'wma'         => 'audio/x-ms-wma',
        'ram'         => 'audio/x-pn-realaudio',
        'rmp'         => 'audio/x-pn-realaudio-plugin',
        'wav'         => 'audio/x-wav',
        'xm'          => 'audio/xm',
        'cdx'         => 'chemical/x-cdx',
        'cif'         => 'chemical/x-cif',
        'cmdf'        => 'chemical/x-cmdf',
        'cml'         => 'chemical/x-cml',
        'csml'        => 'chemical/x-csml',
        'xyz'         => 'chemical/x-xyz',
        'bmp'         => 'image/bmp',
        'cgm'         => 'image/cgm',
        'g3'          => 'image/g3fax',
        'gif'         => 'image/gif',
        'ief'         => 'image/ief',
        'jpg'         => 'image/jpeg',
        'jpeg'        => 'image/jpeg',
        'ktx'         => 'image/ktx',
        'png'         => 'image/png',
        'btif'        => 'image/prs.btif',
        'sgi'         => 'image/sgi',
        'svg'         => 'image/svg+xml',
        'tiff'        => 'image/tiff',
        'psd'         => 'image/vnd.adobe.photoshop',
        'uvi'         => 'image/vnd.dece.graphic',
        'djvu'        => 'image/vnd.djvu',
        'dwg'         => 'image/vnd.dwg',
        'dxf'         => 'image/vnd.dxf',
        'fbs'         => 'image/vnd.fastbidsheet',
        'fpx'         => 'image/vnd.fpx',
        'fst'         => 'image/vnd.fst',
        'mmr'         => 'image/vnd.fujixerox.edmics-mmr',
        'rlc'         => 'image/vnd.fujixerox.edmics-rlc',
        'mdi'         => 'image/vnd.ms-modi',
        'wdp'         => 'image/vnd.ms-photo',
        'npx'         => 'image/vnd.net-fpx',
        'wbmp'        => 'image/vnd.wap.wbmp',
        'xif'         => 'image/vnd.xiff',
        'webp'        => 'image/webp',
        '3ds'         => 'image/x-3ds',
        'ras'         => 'image/x-cmu-raster',
        'cmx'         => 'image/x-cmx',
        'fh'          => 'image/x-freehand',
        'ico'         => 'image/x-icon',
        'sid'         => 'image/x-mrsid-image',
        'pcx'         => 'image/x-pcx',
        'pic'         => 'image/x-pict',
        'pnm'         => 'image/x-portable-anymap',
        'pbm'         => 'image/x-portable-bitmap',
        'pgm'         => 'image/x-portable-graymap',
        'ppm'         => 'image/x-portable-pixmap',
        'rgb'         => 'image/x-rgb',
        'tga'         => 'image/x-tga',
        'xbm'         => 'image/x-xbitmap',
        'xpm'         => 'image/x-xpixmap',
        'xwd'         => 'image/x-xwindowdump',
        'eml'         => 'message/rfc822',
        'igs'         => 'model/iges',
        'msh'         => 'model/mesh',
        'dae'         => 'model/vnd.collada+xml',
        'dwf'         => 'model/vnd.dwf',
        'gdl'         => 'model/vnd.gdl',
        'gtw'         => 'model/vnd.gtw',
        'mts'         => 'model/vnd.mts',
        'vtu'         => 'model/vnd.vtu',
        'wrl'         => 'model/vrml',
        'x3db'        => 'model/x3d+binary',
        'x3dv'        => 'model/x3d+vrml',
        'x3d'         => 'model/x3d+xml',
        'appcache'    => 'text/cache-manifest',
        'ics'         => 'text/calendar',
        'css'         => 'text/css',
        'csv'         => 'text/csv',
        'html'        => 'text/html',
        'n3'          => 'text/n3',
        'txt'         => 'text/plain',
        'dsc'         => 'text/prs.lines.tag',
        'rtx'         => 'text/richtext',
        'rtf'         => 'text/rtf',
        'sgml'        => 'text/sgml',
        'tsv'         => 'text/tab-separated-values',
        't'           => 'text/troff',
        'ttl'         => 'text/turtle',
        'uri'         => 'text/uri-list',
        'vcard'       => 'text/vcard',
        'curl'        => 'text/vnd.curl',
        'dcurl'       => 'text/vnd.curl.dcurl',
        'scurl'       => 'text/vnd.curl.scurl',
        'mcurl'       => 'text/vnd.curl.mcurl',
        'sub'         => 'text/vnd.dvb.subtitle',
        'fly'         => 'text/vnd.fly',
        'flx'         => 'text/vnd.fmi.flexstor',
        'gv'          => 'text/vnd.graphviz',
        '3dml'        => 'text/vnd.in3d.3dml',
        'spot'        => 'text/vnd.in3d.spot',
        'jad'         => 'text/vnd.sun.j2me.app-descriptor',
        'wml'         => 'text/vnd.wap.wml',
        'wmls'        => 'text/vnd.wap.wmlscript',
        's'           => 'text/x-asm',
        'c'           => 'text/x-c',
        'f'           => 'text/x-fortran',
        'p'           => 'text/x-pascal',
        'java'        => 'text/x-java-source',
        'opml'        => 'text/x-opml',
        'nfo'         => 'text/x-nfo',
        'etx'         => 'text/x-setext',
        'sfv'         => 'text/x-sfv',
        'uu'          => 'text/x-uuencode',
        'vcs'         => 'text/x-vcalendar',
        'vcf'         => 'text/x-vcard',
        '3gp'         => 'video/3gpp',
        '3g2'         => 'video/3gpp2',
        'h261'        => 'video/h261',
        'h263'        => 'video/h263',
        'h264'        => 'video/h264',
        'jpgv'        => 'video/jpeg',
        'jpm'         => 'video/jpm',
        'mj2'         => 'video/mj2',
        'mp4'         => 'video/mp4',
        'mpeg'        => 'video/mpeg',
        'ogv'         => 'video/ogg',
        'mov'         => 'video/quicktime',
        'qt'          => 'video/quicktime',
        'uvh'         => 'video/vnd.dece.hd',
        'uvm'         => 'video/vnd.dece.mobile',
        'uvp'         => 'video/vnd.dece.pd',
        'uvs'         => 'video/vnd.dece.sd',
        'uvv'         => 'video/vnd.dece.video',
        'dvb'         => 'video/vnd.dvb.file',
        'fvt'         => 'video/vnd.fvt',
        'mxu'         => 'video/vnd.mpegurl',
        'pyv'         => 'video/vnd.ms-playready.media.pyv',
        'uvu'         => 'video/vnd.uvvu.mp4',
        'viv'         => 'video/vnd.vivo',
        'webm'        => 'video/webm',
        'f4v'         => 'video/x-f4v',
        'fli'         => 'video/x-fli',
        'flv'         => 'video/x-flv',
        'm4v'         => 'video/x-m4v',
        'mkv'         => 'video/x-matroska',
        'mng'         => 'video/x-mng',
        'asf'         => 'video/x-ms-asf',
        'vob'         => 'video/x-ms-vob',
        'wm'          => 'video/x-ms-wm',
        'wmv'         => 'video/x-ms-wmv',
        'wmx'         => 'video/x-ms-wmx',
        'wvx'         => 'video/x-ms-wvx',
        'avi'         => 'video/x-msvideo',
        'movie'       => 'video/x-sgi-movie',
        'smv'         => 'video/x-smv',
        'ice'         => 'x-conference/x-cooltalk',
    ];

    private static $instance = null;

    /**
     * Description: 单例实例化
     * @return File
     * @Author: Bililovy
     * @Date  : 19-6-10 下午9:56
     */
    public static function getInstance()
    {
        if (is_null(self::$instance) || self::$instance instanceof self) {
            self::$instance = new self();
        }

        return self::$instance;
    }

    /**
     * Description: 逐行读取文件
     *
     * @param string $path
     * @param bool $isRemoveFile 是否读取完后删除文件
     *
     * @return array
     * @throws \Exception
     * @Author Bililovy
     * @Time   2021/9/23 17:31
     */
    public static function textFileEachLineReader(string $path, bool $isRemoveFile = false)
    {
        if (! is_file($path)) {
            throw new \Exception($path . '文件不存在');
        }
        $fp = @fopen($path, 'r');
        $content = [];
        do {
            $content[] = fgets($fp, 1024);
        } while (! feof($fp));
        fclose($fp);
        $isRemoveFile && @unlink($path);

        return $content;
    }

    /**
     * Description:
     *
     * @param string $fileName       导出的文件名称，不用带后缀，带了后缀也会过滤掉，全部规定使用xlsx后缀
     * @param array $fileDatas       文件数据，格式：
     *
     *                          [
     *                              'username'=>'张三',
     *                              'age'=>'12',
     *                              'address'=>'四川成都',
     *                              .....
     *                          ]
     * @param string $sheetTitle     活动表的名称
     * @param array $columnHeadData  表头名称，即表头第一行现实的名称，如果不传入，则默认使用 $fileDatas字段的名称
     *                               如果要传入，则格式为：
     *                               ['姓名','年龄','家庭住址',.....]
     * @param array $optionalSetting 其他附加设置，如单元格字体大小，样式，背景色等等，此参数复杂
     *
     *                              [
     *                                  0=>[    // 表示对 第1行所有数据单元格设置样式 后续有需求在升级个性需求
     *                                      'font'=>[
     *                                           'bold'=>true,
     *                                           'size'=>12
     *                                      ]
     *                                    ]
     *                              ]
     *
     *
     * @throws \PhpOffice\PhpSpreadsheet\Exception
     * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
     * @Author: Bililovy
     * @Date  : 19-12-14 下午5:34
     *
     * @Skills: 使用技巧总结:
     *       参考此链接 https://www.cnblogs.com/zx-admin/p/11653863.html
     */
    public function exportExcel(string $fileName, array $fileDatas, string $sheetTitle = '数据', array $columnHeadData = [], array $optionalSetting = [])
    {
        if (! empty($fileDatas)) {
            set_time_limit(0);
            $fileName = preg_replace('/(\.\w+)?$/', '', $fileName);
            $spreadsheet = new Spreadsheet();
            $dataArray = [];
            // 是否将首行设置为表头
            $spreadsheet->getActiveSheet()
                        ->setTitle($sheetTitle);
            if (empty($columnHeadData)) {
                // 如果没有人为设置表头，就用数据第一个元素的key做表头
                if (isset($fileDatas[0])) {
                    $columnHeadData = array_keys($fileDatas[0]);
                }
            }
            if (! empty($columnHeadData)) {
                $dataArray[0] = $columnHeadData;
            }

            // 对数据进行过滤转换
            foreach ($fileDatas as $field => $fileData) {
                $dataArray[] = array_values($fileData);
            }

            // 设置默认行高
            $spreadsheet->getActiveSheet()
                        ->getDefaultRowDimension()
                        ->setRowHeight(25);
            // 设置默认列宽
            $spreadsheet->getActiveSheet()
                        ->getDefaultColumnDimension()
                        ->setAutoSize(true);
            if (! empty($optionalSetting['row_setting'])) {
                // 对整行设置样式
                // 如字体颜色 大小等
                foreach ($optionalSetting['row_setting'] as $row => $value) {
                    if (is_numeric($value['height']) && $value['height'] > 0) {
                        $spreadsheet->getActiveSheet()
                                    ->getRowDimension($row)
                                    ->setRowHeight($value['height']);
                    }
                }
            }

            // 设置列的样式，如高度等
            if (! empty($optionalSetting['column_setting'])) {
                // 对单元格设置样式
                foreach ($optionalSetting['column_setting'] as $column => $value) {
                    if (! empty($value['width'])) {
                        if (is_numeric($value['width']) && $value['width'] > 0) {
                            $spreadsheet->getActiveSheet()
                                        ->getColumnDimension($column)
                                        ->setWidth($value['width']);
                        }
                    }
                }
            }

            if (! empty($optionalSetting['operation'])) {
                foreach ($optionalSetting['operation'] as $operator => $value) {
                    switch ($operator) {
                        case 'merge':
                            foreach ($value as $cells) {
                                foreach ($cells as $cell) {
                                    $spreadsheet->getActiveSheet()
                                                ->mergeCells($cell);
                                }
                            }
                        break;
                    }
                }
            }

            // 对单元格样式设置
            if (! empty($optionalSetting['style'])) {
                foreach ($optionalSetting['style'] as $cell => $styles) {
                    $spreadsheet->getActiveSheet()
                                ->getStyle($cell)
                                ->applyFromArray($styles);
                }
            }

            // 填充数据
            $spreadsheet->getActiveSheet()
                        ->fromArray($dataArray);
            header('Content-Description: File Transfer');
            header('Cache-Control: must-revalidate');
            header('Pragma: public');
            header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
            header('Content-Disposition: attachment;filename=' . $fileName . '.xlsx');
            header("Content-Transfer-Encoding: binary");
            header('Expires: 0');
            header('Cache-Control: max-age=0');
            $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
            $writer->save('php://output');
            $fp = fopen('php://output', 'a');//打开output流
            mb_convert_variables('GBK', 'UTF-8', $dataArray[0]);
            fputcsv($fp, $dataArray[0]);//将数据格式化为xlsx格式并写入到output流中

            //每次导出的条数
            $perSize = 2000;
            $fileDatasChunk = array_chunk($dataArray, $perSize);
            unset($dataArray);
            foreach ($fileDatasChunk as $key => $dataArray) {
                foreach ($dataArray as $item) {
                    mb_convert_variables('GBK', 'UTF-8', $item);
                    fputcsv($fp, $item);
                }
                //刷新输出缓冲到浏览器
                ob_flush();
                flush();//必须同时使用 ob_flush() 和flush() 函数来刷新输出缓冲。
            }
            fclose($fp);
            exit('文件已经下载');
        }
        $msg = '抱歉，下载失败，可能原因为：没有可用数据，或数据结构有错误，请确定数据显示是否正常。<br /><a href="javascript:history.go(-1)">点击这里返回重试</a>';
        exit($msg);
    }

    /**
     * Description: 垂直对齐方式
     *
     * @param string $alignment 对齐方式
     *
     * @return array
     * @Author: Bililovy
     * @Date  : 19-12-16 下午10:14
     */
    public static function getHorizontalAlignments(string $alignment): array
    {
        $return = [];
        $supportAlignments = [
            'general'          => Alignment::HORIZONTAL_GENERAL,
            'left'             => Alignment::HORIZONTAL_LEFT,
            'right'            => Alignment::HORIZONTAL_RIGHT,
            'center'           => Alignment::HORIZONTAL_CENTER,
            'centerContinuous' => Alignment::HORIZONTAL_CENTER_CONTINUOUS,
            'justify'          => Alignment::HORIZONTAL_JUSTIFY,
            'fill'             => Alignment::HORIZONTAL_FILL,
            'distributed'      => Alignment::HORIZONTAL_DISTRIBUTED,
        ];
        if (isset($supportAlignments[$alignment])) {
            $return = [
                'alignment' => [
                    'horizontal' => $supportAlignments[$alignment]
                ],
            ];
        }

        return $return;
    }

    /**
     * Description: 水平对齐方式
     *
     * @param string $alignment 对齐方式
     *
     * @return array
     * @Author: Bililovy
     * @Date  : 19-12-16 下午10:18
     */
    public static function getVerticalAlignments(string $alignment): array
    {
        $return = [];
        $supportAlignments = [
            'Vertical'    => Alignment::VERTICAL_BOTTOM,
            'top'         => Alignment::VERTICAL_TOP,
            'center'      => Alignment::VERTICAL_CENTER,
            'justify'     => Alignment::VERTICAL_JUSTIFY,
            'distributed' => Alignment::HORIZONTAL_DISTRIBUTED,
        ];
        if (isset($supportAlignments[$alignment])) {
            $return = [
                'alignment' => [
                    'vertical' => $supportAlignments[$alignment]
                ],
            ];
        }

        return $return;
    }


    /**
     * Get the MIME type for a file based on the file's extension.
     *
     * @param string $mimeType
     *
     * @return string
     */
    public static function fromMimeType($mimeType)
    {
        return self::getExtensionFromMimeType($mimeType);
    }

    /**
     * Get the MIME type for a given extension or return all mimes.
     *
     * @param string|null $extension
     *
     * @return string|array
     */
    public static function getMimeType($extension = null)
    {
        return $extension ? self::getMimeTypeFromExtension($extension) : self::$mimes;
    }

    /**
     * Search for the extension of a given MIME type.
     *
     * @param string $mimeType
     *
     * @return string|null
     */
    public static function search($mimeType)
    {
        return array_search($mimeType, self::$mimes) ?: null;
    }

    /**
     * Get the MIME type for a given extension.
     *
     * @param string $extension
     *
     * @return string
     */
    protected static function getMimeTypeFromExtension($extension)
    {
        return self::$mimes[$extension] ?? 'application/octet-stream';
    }

    /**
     * Get the MIME type for a given extension.
     *
     * @param string $mimeType
     *
     * @return string
     */
    protected static function getExtensionFromMimeType($mimeType)
    {
        $extensions = array_flip(self::$mimes);

        return $extensions[$mimeType] ?? '';
    }


    /**
     * Description: 根据指定的 表头 读取此网吧的excel表头
     *
     * @param array $columnTitleArray
     * @param array $rowStyle 对指定单元格设置样式
     *
     * @return array  返回结果 ：
     *                  array:1 [
     *                      0 => array:2 [
     *                          "select_column" => "A1:B1:C1:D1:E1:F1:G1:H1:I1"
     *                          "column_style" => array:1 [
     *                              "font" => array:2 [
     *                              "bold" => true
     *                              "size" => 14
     *                              ]
     *                          ]
     *                      ]
     *                  ]
     * @Author: Bililovy
     * @Date  : 19-12-14 下午4:37
     */
    private function createColumnTitle(array $columnTitleArray, array $rowStyle = [])
    {
        $columnFlagCount = count($columnTitleArray);
        $columnFormat = [];
        foreach ($rowStyle as $row => $style) {
            $rowIndex = $row + 1;
            $colIndexArray = [];
            for ($i = 0; $i < $columnFlagCount; $i++) {
                $pColumnIndex = $i;
                if ($pColumnIndex < 26) {
                    $columnName = chr(65 + $pColumnIndex) . $rowIndex;
                } elseif ($pColumnIndex < 702) {
                    $columnName = chr(64 + ($pColumnIndex / 26)) . chr(65 + $pColumnIndex % 26) . $rowIndex;
                } else {
                    $columnName = chr(64 + (($pColumnIndex - 26) / 676)) . chr(65 + ((($pColumnIndex - 26) % 676) / 26)) . chr(65 + $pColumnIndex % 26) . $rowIndex;
                }
                $colIndexArray[] = $columnName;
            }
            $columnFormat[$row]['all_select_column'] = $colIndexArray;
            $columnFormat[$row]['select_column_range'] = $colIndexArray[0] . ':' . $colIndexArray[count($colIndexArray) - 1];
            $columnFormat[$row]['column_style'] = $style;
            unset($colIndexArray);
        }

        return $columnFormat;
    }
}
